How to split characters and numbers in Microsoft Excel

4/22/2020

Applies to versions of Excel 2013 and above.

Suppose you have the following data:

Your task is to separate letters and numbers, use the following method. This is considered the fastest way and does not need to use functions or code.